﻿using System;
using System.Collections.Generic;
using System.Text;

namespace DatabaseHelper.Core.Models
{
    public class ColumnViewEntity
    {

        public string DatabaseName { get; set; }
        public string TableName { get; set; }
        public string SchemaName { get; set; }
        public string ColumnName { get; set; }
        public int OrdinalPosition { get; set; }
        public bool IsNullable { get; set; }
        public bool IsIdentity { get; set; }
        public bool IsRowGuidCol { get; set; }
        public bool IsPrimaryKey { get; set; }
        public string DataType { get; set; }
        public string CharacterMaximumLength { get; set; }
        public string CharacterOctetLength { get; set; }
        public string CharacterSetSchema { get; set; }
        public string CollationSchema { get; set; }
        public string ColumnDescription { get; set; }
        
        #region 浮点数精度
        public string NumericPrecision { get; set; }
        public string NumericPrecisionRadix { get; set; }
        public string NumericScale { get; set; }
        #endregion

        #region 日期精度
        public string DateTimePrecision { get; set; }
        #endregion
    }
}
